MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Alpha Sort = 5941

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
70539 70539 1979.43.4a, b 0 0 84511 Costume Institute 8 Ball gown 5911 Ball gown French 7         Designer 5 Attributed to Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 1950–51 1950 1951 silk 15101   Gift of Mrs. Richard B. Englund, 1979                           http://www.metmuseum.org/art/collection/search/84511 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70621 70621 C.I.59.37.1 0 0 84600 Costume Institute 8 Evening coat 5920 Evening coat French 7         Designer 5   Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 ca. 1934 1929 1939 silk, metal, fur 16261   Gift of Mrs. Maxime L. Hermanos, 1959                           http://www.metmuseum.org/art/collection/search/84600 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70740 70740 C.I.59.37.2a, b 0 0 84779 Costume Institute 8 Cocktail Dress 5933 Cocktail dress French 7         Designer 5   Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 1934–36 1934 1936 silk 15101   Gift of Mrs. Maxime L. Hermanos, 1959                           http://www.metmuseum.org/art/collection/search/84779 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70745 70745 1974.127a–c 0 0 84785 Costume Institute 8 Ensemble 5875 Ensemble French 7         Designer 5   Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 1936 1936 1936 (a) wool; (b,c) silk 16290   Gift of Mrs. Phillip Bastedo, 1974                           http://www.metmuseum.org/art/collection/search/84785 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70747 70747 C.I.57.33.1 0 0 84787 Costume Institute 8 Coat 4973 Coat French 7         Designer 5   Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 1938 1938 1938 wool, silk, metal 15268   Gift of Mrs. Manuel Rosenberg, 1957                           http://www.metmuseum.org/art/collection/search/84787 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
78058 78058 1978.245 0 0 103377 Costume Institute 8 Dress 5877 Dress French 7         Designer 5 Attributed to Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 ca. 1922 1917 1927 cotton, silk, metallic thread 17525   Gift of Mrs. Janos Scholz (Helen Marshall), 1978                           http://www.metmuseum.org/art/collection/search/103377 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80690 80690 1978.583.63 0 0 108901 Costume Institute 8 Teddy 6130 Teddy French 7         Designer 5 Attributed to Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 1920s 1920 1929 silk 15101   Gift of Mrs. Janos Scholz (Helen Marshall), 1978                           http://www.metmuseum.org/art/collection/search/108901 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
81168 81168 1986.516.1 0 0 109552 Costume Institute 8 Blouse 5953 Blouse probably French 203         Designer 5 Attributed to Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 1920s 1920 1929 silk, cotton 15149   Gift of Miriam W. Coletti, 1986                           http://www.metmuseum.org/art/collection/search/109552 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
96900 96900 2009.300.7151 0 0 174279 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer 5   Maggy Rouff French, 1896–1971   Rouff Maggy 5941 French 2 1896 1971 ca. 1935 1933 1937 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mr. and Mrs. Maxime L. Hermanos, 1961                           http://www.metmuseum.org/art/collection/search/174279 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 136.221ms · Data license: CC0 · Data source: metmuseum/openaccess